package com.itheima.heimademo01.mapper;


import com.itheima.heimademo01.pojo.entity.Category;
import org.apache.ibatis.annotations.*;

import java.util.List;

public interface CategoryMapper {
    // 新增文章分类
    @Insert("insert into category(category_name,category_alias,create_user,create_time,update_time) values(#{category.categoryName},#{category.categoryAlias},#{category.createUser},#{category.createTime}, #{category.updateTime})")
    void category(@Param("category") Category category);

    // 文章分类列表
    @Select("select * from category where create_user = #{userId}")
    List<Category> list(@Param("userId") Integer userId);

    // 获取文章分类详情
    @Select("select * from category where id =#{id}")
    Category detail(@Param("id") Integer id);

    // 更新文章分类
    @Update("update category set category_name=#{category.categoryName},category_alias=#{category.categoryAlias},update_time=#{category.updateTime} where id =#{category.id}")
    void update(@Param("category") Category category);

    // 删除文章分类
    @Delete("delete from category where id = #{id}")
    void delete(@Param("id") Integer id);
}
